<?php if (!defined('TL_ROOT')) die('You cannot access this file directly!');

/**
 * Contao Open Source CMS
 * Copyright (C) 2005-2011 Leo Feyer
 *
 * Formerly known as TYPOlight Open Source CMS.
 *
 * This program is free software: you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation, either
 * version 3 of the License, or (at your option) any later version.
 * 
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
 * Lesser General Public License for more details.
 * 
 * You should have received a copy of the GNU Lesser General Public
 * License along with this program. If not, please visit the Free
 * Software Foundation website at <http://www.gnu.org/licenses/>.
 *
 * PHP version 5
 * @copyright  2011 Andreas Koob 
 * @author     Andreas Koob 
 * @package    tasks 
 * @license    LGPL 
 * @filesource
 */


/**
 * Class projectlist 
 *
 * @copyright  2011 Andreas Koob 
 * @author     Andreas Koob 
 * @package    Controller
 */
class tm_projectlist extends ContentElement
{

	/**
	 * Template
	 * @var string
	 */
	protected $strTemplate = 'tm_projectlist';


	public function generate()
	{
		if (TL_MODE == 'BE')
		{
			$return="Tasks - Project list";
			return $return;
		}
		return parent::generate();
	}
	
	/**
	 * Generate module
	 */
	protected function compile()
	{
		$objProjects = $this->Database->prepare("SELECT * FROM tl_tm_projects ORDER BY project_order ASC")->execute();
		$objTargetPage = $this->Database->prepare("SELECT id, alias FROM tl_page WHERE id=?")
												->limit(1)
												->execute($this->tm_redirect_project);
		while($objProjects->next()){
				$objTasks = $this->Database->prepare("SELECT count(id) as cnt_tasks FROM tl_tm_tasks WHERE pid=?")->execute($objProjects->id);
				$arrRet[]=array(
				'id'=>$objProjects->id,
				'name'=>$objProjects->name,
				'tasks'=>$objTasks->cnt_tasks,
				'redirect'=>$this->generateFrontendUrl($objTargetPage->row(),'/project/' . $objProjects->id)
				);
		}
		$this->Template->projects=$arrRet;
	}
}

?>